package com.esun.payment_api.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class DkClaimExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DkClaimExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUuidIsNull() {
            addCriterion("UUID is null");
            return (Criteria) this;
        }

        public Criteria andUuidIsNotNull() {
            addCriterion("UUID is not null");
            return (Criteria) this;
        }

        public Criteria andUuidEqualTo(String value) {
            addCriterion("UUID =", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotEqualTo(String value) {
            addCriterion("UUID <>", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidGreaterThan(String value) {
            addCriterion("UUID >", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidGreaterThanOrEqualTo(String value) {
            addCriterion("UUID >=", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidLessThan(String value) {
            addCriterion("UUID <", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidLessThanOrEqualTo(String value) {
            addCriterion("UUID <=", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidLike(String value) {
            addCriterion("UUID like", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotLike(String value) {
            addCriterion("UUID not like", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidIn(List<String> values) {
            addCriterion("UUID in", values, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotIn(List<String> values) {
            addCriterion("UUID not in", values, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidBetween(String value1, String value2) {
            addCriterion("UUID between", value1, value2, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotBetween(String value1, String value2) {
            addCriterion("UUID not between", value1, value2, "uuid");
            return (Criteria) this;
        }

        public Criteria andCoIdIsNull() {
            addCriterion("CO_ID is null");
            return (Criteria) this;
        }

        public Criteria andCoIdIsNotNull() {
            addCriterion("CO_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCoIdEqualTo(Short value) {
            addCriterion("CO_ID =", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdNotEqualTo(Short value) {
            addCriterion("CO_ID <>", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdGreaterThan(Short value) {
            addCriterion("CO_ID >", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdGreaterThanOrEqualTo(Short value) {
            addCriterion("CO_ID >=", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdLessThan(Short value) {
            addCriterion("CO_ID <", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdLessThanOrEqualTo(Short value) {
            addCriterion("CO_ID <=", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdIn(List<Short> values) {
            addCriterion("CO_ID in", values, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdNotIn(List<Short> values) {
            addCriterion("CO_ID not in", values, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdBetween(Short value1, Short value2) {
            addCriterion("CO_ID between", value1, value2, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdNotBetween(Short value1, Short value2) {
            addCriterion("CO_ID not between", value1, value2, "coId");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andBankTypeIsNull() {
            addCriterion("BANK_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andBankTypeIsNotNull() {
            addCriterion("BANK_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andBankTypeEqualTo(Short value) {
            addCriterion("BANK_TYPE =", value, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeNotEqualTo(Short value) {
            addCriterion("BANK_TYPE <>", value, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeGreaterThan(Short value) {
            addCriterion("BANK_TYPE >", value, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("BANK_TYPE >=", value, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeLessThan(Short value) {
            addCriterion("BANK_TYPE <", value, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeLessThanOrEqualTo(Short value) {
            addCriterion("BANK_TYPE <=", value, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeIn(List<Short> values) {
            addCriterion("BANK_TYPE in", values, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeNotIn(List<Short> values) {
            addCriterion("BANK_TYPE not in", values, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeBetween(Short value1, Short value2) {
            addCriterion("BANK_TYPE between", value1, value2, "bankType");
            return (Criteria) this;
        }

        public Criteria andBankTypeNotBetween(Short value1, Short value2) {
            addCriterion("BANK_TYPE not between", value1, value2, "bankType");
            return (Criteria) this;
        }

        public Criteria andClaimDateIsNull() {
            addCriterion("CLAIM_DATE is null");
            return (Criteria) this;
        }

        public Criteria andClaimDateIsNotNull() {
            addCriterion("CLAIM_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andClaimDateEqualTo(Date value) {
            addCriterion("CLAIM_DATE =", value, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateNotEqualTo(Date value) {
            addCriterion("CLAIM_DATE <>", value, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateGreaterThan(Date value) {
            addCriterion("CLAIM_DATE >", value, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CLAIM_DATE >=", value, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateLessThan(Date value) {
            addCriterion("CLAIM_DATE <", value, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateLessThanOrEqualTo(Date value) {
            addCriterion("CLAIM_DATE <=", value, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateIn(List<Date> values) {
            addCriterion("CLAIM_DATE in", values, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateNotIn(List<Date> values) {
            addCriterion("CLAIM_DATE not in", values, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateBetween(Date value1, Date value2) {
            addCriterion("CLAIM_DATE between", value1, value2, "claimDate");
            return (Criteria) this;
        }

        public Criteria andClaimDateNotBetween(Date value1, Date value2) {
            addCriterion("CLAIM_DATE not between", value1, value2, "claimDate");
            return (Criteria) this;
        }

        public Criteria andReceiveIdIsNull() {
            addCriterion("RECEIVE_ID is null");
            return (Criteria) this;
        }

        public Criteria andReceiveIdIsNotNull() {
            addCriterion("RECEIVE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveIdEqualTo(Integer value) {
            addCriterion("RECEIVE_ID =", value, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdNotEqualTo(Integer value) {
            addCriterion("RECEIVE_ID <>", value, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdGreaterThan(Integer value) {
            addCriterion("RECEIVE_ID >", value, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("RECEIVE_ID >=", value, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdLessThan(Integer value) {
            addCriterion("RECEIVE_ID <", value, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdLessThanOrEqualTo(Integer value) {
            addCriterion("RECEIVE_ID <=", value, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdIn(List<Integer> values) {
            addCriterion("RECEIVE_ID in", values, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdNotIn(List<Integer> values) {
            addCriterion("RECEIVE_ID not in", values, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdBetween(Integer value1, Integer value2) {
            addCriterion("RECEIVE_ID between", value1, value2, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveIdNotBetween(Integer value1, Integer value2) {
            addCriterion("RECEIVE_ID not between", value1, value2, "receiveId");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyIsNull() {
            addCriterion("RECEIVE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyIsNotNull() {
            addCriterion("RECEIVE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyEqualTo(BigDecimal value) {
            addCriterion("RECEIVE_MONEY =", value, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyNotEqualTo(BigDecimal value) {
            addCriterion("RECEIVE_MONEY <>", value, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyGreaterThan(BigDecimal value) {
            addCriterion("RECEIVE_MONEY >", value, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RECEIVE_MONEY >=", value, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyLessThan(BigDecimal value) {
            addCriterion("RECEIVE_MONEY <", value, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RECEIVE_MONEY <=", value, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyIn(List<BigDecimal> values) {
            addCriterion("RECEIVE_MONEY in", values, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyNotIn(List<BigDecimal> values) {
            addCriterion("RECEIVE_MONEY not in", values, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RECEIVE_MONEY between", value1, value2, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andReceiveMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RECEIVE_MONEY not between", value1, value2, "receiveMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyIsNull() {
            addCriterion("CLAIM_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyIsNotNull() {
            addCriterion("CLAIM_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyEqualTo(BigDecimal value) {
            addCriterion("CLAIM_MONEY =", value, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyNotEqualTo(BigDecimal value) {
            addCriterion("CLAIM_MONEY <>", value, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyGreaterThan(BigDecimal value) {
            addCriterion("CLAIM_MONEY >", value, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CLAIM_MONEY >=", value, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyLessThan(BigDecimal value) {
            addCriterion("CLAIM_MONEY <", value, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CLAIM_MONEY <=", value, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyIn(List<BigDecimal> values) {
            addCriterion("CLAIM_MONEY in", values, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyNotIn(List<BigDecimal> values) {
            addCriterion("CLAIM_MONEY not in", values, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CLAIM_MONEY between", value1, value2, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andClaimMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CLAIM_MONEY not between", value1, value2, "claimMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyIsNull() {
            addCriterion("INVOICE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyIsNotNull() {
            addCriterion("INVOICE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyEqualTo(BigDecimal value) {
            addCriterion("INVOICE_MONEY =", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyNotEqualTo(BigDecimal value) {
            addCriterion("INVOICE_MONEY <>", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyGreaterThan(BigDecimal value) {
            addCriterion("INVOICE_MONEY >", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("INVOICE_MONEY >=", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyLessThan(BigDecimal value) {
            addCriterion("INVOICE_MONEY <", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("INVOICE_MONEY <=", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyIn(List<BigDecimal> values) {
            addCriterion("INVOICE_MONEY in", values, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyNotIn(List<BigDecimal> values) {
            addCriterion("INVOICE_MONEY not in", values, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INVOICE_MONEY between", value1, value2, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INVOICE_MONEY not between", value1, value2, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyIsNull() {
            addCriterion("PAYABLE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyIsNotNull() {
            addCriterion("PAYABLE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyEqualTo(BigDecimal value) {
            addCriterion("PAYABLE_MONEY =", value, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyNotEqualTo(BigDecimal value) {
            addCriterion("PAYABLE_MONEY <>", value, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyGreaterThan(BigDecimal value) {
            addCriterion("PAYABLE_MONEY >", value, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PAYABLE_MONEY >=", value, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyLessThan(BigDecimal value) {
            addCriterion("PAYABLE_MONEY <", value, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PAYABLE_MONEY <=", value, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyIn(List<BigDecimal> values) {
            addCriterion("PAYABLE_MONEY in", values, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyNotIn(List<BigDecimal> values) {
            addCriterion("PAYABLE_MONEY not in", values, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PAYABLE_MONEY between", value1, value2, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PAYABLE_MONEY not between", value1, value2, "payableMoney");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("CREATE_BY is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("CREATE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(Short value) {
            addCriterion("CREATE_BY =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(Short value) {
            addCriterion("CREATE_BY <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(Short value) {
            addCriterion("CREATE_BY >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(Short value) {
            addCriterion("CREATE_BY >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(Short value) {
            addCriterion("CREATE_BY <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(Short value) {
            addCriterion("CREATE_BY <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<Short> values) {
            addCriterion("CREATE_BY in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<Short> values) {
            addCriterion("CREATE_BY not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(Short value1, Short value2) {
            addCriterion("CREATE_BY between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(Short value1, Short value2) {
            addCriterion("CREATE_BY not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateAtIsNull() {
            addCriterion("CREATE_AT is null");
            return (Criteria) this;
        }

        public Criteria andCreateAtIsNotNull() {
            addCriterion("CREATE_AT is not null");
            return (Criteria) this;
        }

        public Criteria andCreateAtEqualTo(Date value) {
            addCriterion("CREATE_AT =", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtNotEqualTo(Date value) {
            addCriterion("CREATE_AT <>", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtGreaterThan(Date value) {
            addCriterion("CREATE_AT >", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_AT >=", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtLessThan(Date value) {
            addCriterion("CREATE_AT <", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_AT <=", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtIn(List<Date> values) {
            addCriterion("CREATE_AT in", values, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtNotIn(List<Date> values) {
            addCriterion("CREATE_AT not in", values, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtBetween(Date value1, Date value2) {
            addCriterion("CREATE_AT between", value1, value2, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_AT not between", value1, value2, "createAt");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("UPDATE_BY is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("UPDATE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(Short value) {
            addCriterion("UPDATE_BY =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(Short value) {
            addCriterion("UPDATE_BY <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(Short value) {
            addCriterion("UPDATE_BY >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(Short value) {
            addCriterion("UPDATE_BY >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(Short value) {
            addCriterion("UPDATE_BY <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(Short value) {
            addCriterion("UPDATE_BY <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<Short> values) {
            addCriterion("UPDATE_BY in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<Short> values) {
            addCriterion("UPDATE_BY not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(Short value1, Short value2) {
            addCriterion("UPDATE_BY between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(Short value1, Short value2) {
            addCriterion("UPDATE_BY not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateAtIsNull() {
            addCriterion("UPDATE_AT is null");
            return (Criteria) this;
        }

        public Criteria andUpdateAtIsNotNull() {
            addCriterion("UPDATE_AT is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateAtEqualTo(Date value) {
            addCriterion("UPDATE_AT =", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtNotEqualTo(Date value) {
            addCriterion("UPDATE_AT <>", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtGreaterThan(Date value) {
            addCriterion("UPDATE_AT >", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_AT >=", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtLessThan(Date value) {
            addCriterion("UPDATE_AT <", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_AT <=", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtIn(List<Date> values) {
            addCriterion("UPDATE_AT in", values, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtNotIn(List<Date> values) {
            addCriterion("UPDATE_AT not in", values, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtBetween(Date value1, Date value2) {
            addCriterion("UPDATE_AT between", value1, value2, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_AT not between", value1, value2, "updateAt");
            return (Criteria) this;
        }

        public Criteria andDeleteByIsNull() {
            addCriterion("DELETE_BY is null");
            return (Criteria) this;
        }

        public Criteria andDeleteByIsNotNull() {
            addCriterion("DELETE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteByEqualTo(Short value) {
            addCriterion("DELETE_BY =", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByNotEqualTo(Short value) {
            addCriterion("DELETE_BY <>", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByGreaterThan(Short value) {
            addCriterion("DELETE_BY >", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETE_BY >=", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByLessThan(Short value) {
            addCriterion("DELETE_BY <", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByLessThanOrEqualTo(Short value) {
            addCriterion("DELETE_BY <=", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByIn(List<Short> values) {
            addCriterion("DELETE_BY in", values, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByNotIn(List<Short> values) {
            addCriterion("DELETE_BY not in", values, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByBetween(Short value1, Short value2) {
            addCriterion("DELETE_BY between", value1, value2, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByNotBetween(Short value1, Short value2) {
            addCriterion("DELETE_BY not between", value1, value2, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteAtIsNull() {
            addCriterion("DELETE_AT is null");
            return (Criteria) this;
        }

        public Criteria andDeleteAtIsNotNull() {
            addCriterion("DELETE_AT is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteAtEqualTo(Date value) {
            addCriterion("DELETE_AT =", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtNotEqualTo(Date value) {
            addCriterion("DELETE_AT <>", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtGreaterThan(Date value) {
            addCriterion("DELETE_AT >", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtGreaterThanOrEqualTo(Date value) {
            addCriterion("DELETE_AT >=", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtLessThan(Date value) {
            addCriterion("DELETE_AT <", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtLessThanOrEqualTo(Date value) {
            addCriterion("DELETE_AT <=", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtIn(List<Date> values) {
            addCriterion("DELETE_AT in", values, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtNotIn(List<Date> values) {
            addCriterion("DELETE_AT not in", values, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtBetween(Date value1, Date value2) {
            addCriterion("DELETE_AT between", value1, value2, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtNotBetween(Date value1, Date value2) {
            addCriterion("DELETE_AT not between", value1, value2, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("REMARKS =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("REMARKS <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("REMARKS >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("REMARKS >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("REMARKS <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("REMARKS <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("REMARKS like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("REMARKS not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("REMARKS in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("REMARKS not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("REMARKS between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("REMARKS not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdIsNull() {
            addCriterion("OP_DEPT_ID is null");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdIsNotNull() {
            addCriterion("OP_DEPT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdEqualTo(Short value) {
            addCriterion("OP_DEPT_ID =", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdNotEqualTo(Short value) {
            addCriterion("OP_DEPT_ID <>", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdGreaterThan(Short value) {
            addCriterion("OP_DEPT_ID >", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdGreaterThanOrEqualTo(Short value) {
            addCriterion("OP_DEPT_ID >=", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdLessThan(Short value) {
            addCriterion("OP_DEPT_ID <", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdLessThanOrEqualTo(Short value) {
            addCriterion("OP_DEPT_ID <=", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdIn(List<Short> values) {
            addCriterion("OP_DEPT_ID in", values, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdNotIn(List<Short> values) {
            addCriterion("OP_DEPT_ID not in", values, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdBetween(Short value1, Short value2) {
            addCriterion("OP_DEPT_ID between", value1, value2, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdNotBetween(Short value1, Short value2) {
            addCriterion("OP_DEPT_ID not between", value1, value2, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIsNull() {
            addCriterion("OPERATOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIsNotNull() {
            addCriterion("OPERATOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorIdEqualTo(Short value) {
            addCriterion("OPERATOR_ID =", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotEqualTo(Short value) {
            addCriterion("OPERATOR_ID <>", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdGreaterThan(Short value) {
            addCriterion("OPERATOR_ID >", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdGreaterThanOrEqualTo(Short value) {
            addCriterion("OPERATOR_ID >=", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLessThan(Short value) {
            addCriterion("OPERATOR_ID <", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLessThanOrEqualTo(Short value) {
            addCriterion("OPERATOR_ID <=", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIn(List<Short> values) {
            addCriterion("OPERATOR_ID in", values, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotIn(List<Short> values) {
            addCriterion("OPERATOR_ID not in", values, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdBetween(Short value1, Short value2) {
            addCriterion("OPERATOR_ID between", value1, value2, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotBetween(Short value1, Short value2) {
            addCriterion("OPERATOR_ID not between", value1, value2, "operatorId");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("IS_DELETED is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("IS_DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(String value) {
            addCriterion("IS_DELETED =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(String value) {
            addCriterion("IS_DELETED <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(String value) {
            addCriterion("IS_DELETED >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DELETED >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(String value) {
            addCriterion("IS_DELETED <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(String value) {
            addCriterion("IS_DELETED <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(String value) {
            addCriterion("IS_DELETED like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(String value) {
            addCriterion("IS_DELETED not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<String> values) {
            addCriterion("IS_DELETED in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<String> values) {
            addCriterion("IS_DELETED not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(String value1, String value2) {
            addCriterion("IS_DELETED between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(String value1, String value2) {
            addCriterion("IS_DELETED not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andFlowStatusIsNull() {
            addCriterion("FLOW_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andFlowStatusIsNotNull() {
            addCriterion("FLOW_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andFlowStatusEqualTo(String value) {
            addCriterion("FLOW_STATUS =", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotEqualTo(String value) {
            addCriterion("FLOW_STATUS <>", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusGreaterThan(String value) {
            addCriterion("FLOW_STATUS >", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusGreaterThanOrEqualTo(String value) {
            addCriterion("FLOW_STATUS >=", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusLessThan(String value) {
            addCriterion("FLOW_STATUS <", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusLessThanOrEqualTo(String value) {
            addCriterion("FLOW_STATUS <=", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusLike(String value) {
            addCriterion("FLOW_STATUS like", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotLike(String value) {
            addCriterion("FLOW_STATUS not like", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusIn(List<String> values) {
            addCriterion("FLOW_STATUS in", values, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotIn(List<String> values) {
            addCriterion("FLOW_STATUS not in", values, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusBetween(String value1, String value2) {
            addCriterion("FLOW_STATUS between", value1, value2, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotBetween(String value1, String value2) {
            addCriterion("FLOW_STATUS not between", value1, value2, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptIsNull() {
            addCriterion("RESPONSIBLE_DEPT is null");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptIsNotNull() {
            addCriterion("RESPONSIBLE_DEPT is not null");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptEqualTo(String value) {
            addCriterion("RESPONSIBLE_DEPT =", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptNotEqualTo(String value) {
            addCriterion("RESPONSIBLE_DEPT <>", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptGreaterThan(String value) {
            addCriterion("RESPONSIBLE_DEPT >", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptGreaterThanOrEqualTo(String value) {
            addCriterion("RESPONSIBLE_DEPT >=", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptLessThan(String value) {
            addCriterion("RESPONSIBLE_DEPT <", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptLessThanOrEqualTo(String value) {
            addCriterion("RESPONSIBLE_DEPT <=", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptLike(String value) {
            addCriterion("RESPONSIBLE_DEPT like", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptNotLike(String value) {
            addCriterion("RESPONSIBLE_DEPT not like", value, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptIn(List<String> values) {
            addCriterion("RESPONSIBLE_DEPT in", values, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptNotIn(List<String> values) {
            addCriterion("RESPONSIBLE_DEPT not in", values, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptBetween(String value1, String value2) {
            addCriterion("RESPONSIBLE_DEPT between", value1, value2, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andResponsibleDeptNotBetween(String value1, String value2) {
            addCriterion("RESPONSIBLE_DEPT not between", value1, value2, "responsibleDept");
            return (Criteria) this;
        }

        public Criteria andCheckMemoIsNull() {
            addCriterion("CHECK_MEMO is null");
            return (Criteria) this;
        }

        public Criteria andCheckMemoIsNotNull() {
            addCriterion("CHECK_MEMO is not null");
            return (Criteria) this;
        }

        public Criteria andCheckMemoEqualTo(String value) {
            addCriterion("CHECK_MEMO =", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotEqualTo(String value) {
            addCriterion("CHECK_MEMO <>", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoGreaterThan(String value) {
            addCriterion("CHECK_MEMO >", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoGreaterThanOrEqualTo(String value) {
            addCriterion("CHECK_MEMO >=", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoLessThan(String value) {
            addCriterion("CHECK_MEMO <", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoLessThanOrEqualTo(String value) {
            addCriterion("CHECK_MEMO <=", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoLike(String value) {
            addCriterion("CHECK_MEMO like", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotLike(String value) {
            addCriterion("CHECK_MEMO not like", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoIn(List<String> values) {
            addCriterion("CHECK_MEMO in", values, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotIn(List<String> values) {
            addCriterion("CHECK_MEMO not in", values, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoBetween(String value1, String value2) {
            addCriterion("CHECK_MEMO between", value1, value2, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotBetween(String value1, String value2) {
            addCriterion("CHECK_MEMO not between", value1, value2, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCusIdIsNull() {
            addCriterion("CUS_ID is null");
            return (Criteria) this;
        }

        public Criteria andCusIdIsNotNull() {
            addCriterion("CUS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCusIdEqualTo(Integer value) {
            addCriterion("CUS_ID =", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdNotEqualTo(Integer value) {
            addCriterion("CUS_ID <>", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdGreaterThan(Integer value) {
            addCriterion("CUS_ID >", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUS_ID >=", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdLessThan(Integer value) {
            addCriterion("CUS_ID <", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdLessThanOrEqualTo(Integer value) {
            addCriterion("CUS_ID <=", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdIn(List<Integer> values) {
            addCriterion("CUS_ID in", values, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdNotIn(List<Integer> values) {
            addCriterion("CUS_ID not in", values, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdBetween(Integer value1, Integer value2) {
            addCriterion("CUS_ID between", value1, value2, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CUS_ID not between", value1, value2, "cusId");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceIsNull() {
            addCriterion("NEED_INVOICE is null");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceIsNotNull() {
            addCriterion("NEED_INVOICE is not null");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceEqualTo(Short value) {
            addCriterion("NEED_INVOICE =", value, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceNotEqualTo(Short value) {
            addCriterion("NEED_INVOICE <>", value, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceGreaterThan(Short value) {
            addCriterion("NEED_INVOICE >", value, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceGreaterThanOrEqualTo(Short value) {
            addCriterion("NEED_INVOICE >=", value, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceLessThan(Short value) {
            addCriterion("NEED_INVOICE <", value, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceLessThanOrEqualTo(Short value) {
            addCriterion("NEED_INVOICE <=", value, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceIn(List<Short> values) {
            addCriterion("NEED_INVOICE in", values, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceNotIn(List<Short> values) {
            addCriterion("NEED_INVOICE not in", values, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceBetween(Short value1, Short value2) {
            addCriterion("NEED_INVOICE between", value1, value2, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedInvoiceNotBetween(Short value1, Short value2) {
            addCriterion("NEED_INVOICE not between", value1, value2, "needInvoice");
            return (Criteria) this;
        }

        public Criteria andNeedContractIsNull() {
            addCriterion("NEED_CONTRACT is null");
            return (Criteria) this;
        }

        public Criteria andNeedContractIsNotNull() {
            addCriterion("NEED_CONTRACT is not null");
            return (Criteria) this;
        }

        public Criteria andNeedContractEqualTo(Short value) {
            addCriterion("NEED_CONTRACT =", value, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractNotEqualTo(Short value) {
            addCriterion("NEED_CONTRACT <>", value, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractGreaterThan(Short value) {
            addCriterion("NEED_CONTRACT >", value, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractGreaterThanOrEqualTo(Short value) {
            addCriterion("NEED_CONTRACT >=", value, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractLessThan(Short value) {
            addCriterion("NEED_CONTRACT <", value, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractLessThanOrEqualTo(Short value) {
            addCriterion("NEED_CONTRACT <=", value, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractIn(List<Short> values) {
            addCriterion("NEED_CONTRACT in", values, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractNotIn(List<Short> values) {
            addCriterion("NEED_CONTRACT not in", values, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractBetween(Short value1, Short value2) {
            addCriterion("NEED_CONTRACT between", value1, value2, "needContract");
            return (Criteria) this;
        }

        public Criteria andNeedContractNotBetween(Short value1, Short value2) {
            addCriterion("NEED_CONTRACT not between", value1, value2, "needContract");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeIsNull() {
            addCriterion("RECEIVE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeIsNotNull() {
            addCriterion("RECEIVE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeEqualTo(String value) {
            addCriterion("RECEIVE_TYPE =", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotEqualTo(String value) {
            addCriterion("RECEIVE_TYPE <>", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeGreaterThan(String value) {
            addCriterion("RECEIVE_TYPE >", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeGreaterThanOrEqualTo(String value) {
            addCriterion("RECEIVE_TYPE >=", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeLessThan(String value) {
            addCriterion("RECEIVE_TYPE <", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeLessThanOrEqualTo(String value) {
            addCriterion("RECEIVE_TYPE <=", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeLike(String value) {
            addCriterion("RECEIVE_TYPE like", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotLike(String value) {
            addCriterion("RECEIVE_TYPE not like", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeIn(List<String> values) {
            addCriterion("RECEIVE_TYPE in", values, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotIn(List<String> values) {
            addCriterion("RECEIVE_TYPE not in", values, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeBetween(String value1, String value2) {
            addCriterion("RECEIVE_TYPE between", value1, value2, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotBetween(String value1, String value2) {
            addCriterion("RECEIVE_TYPE not between", value1, value2, "receiveType");
            return (Criteria) this;
        }

        public Criteria andIsCancelledIsNull() {
            addCriterion("IS_CANCELLED is null");
            return (Criteria) this;
        }

        public Criteria andIsCancelledIsNotNull() {
            addCriterion("IS_CANCELLED is not null");
            return (Criteria) this;
        }

        public Criteria andIsCancelledEqualTo(String value) {
            addCriterion("IS_CANCELLED =", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotEqualTo(String value) {
            addCriterion("IS_CANCELLED <>", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledGreaterThan(String value) {
            addCriterion("IS_CANCELLED >", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledGreaterThanOrEqualTo(String value) {
            addCriterion("IS_CANCELLED >=", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledLessThan(String value) {
            addCriterion("IS_CANCELLED <", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledLessThanOrEqualTo(String value) {
            addCriterion("IS_CANCELLED <=", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledLike(String value) {
            addCriterion("IS_CANCELLED like", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotLike(String value) {
            addCriterion("IS_CANCELLED not like", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledIn(List<String> values) {
            addCriterion("IS_CANCELLED in", values, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotIn(List<String> values) {
            addCriterion("IS_CANCELLED not in", values, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledBetween(String value1, String value2) {
            addCriterion("IS_CANCELLED between", value1, value2, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotBetween(String value1, String value2) {
            addCriterion("IS_CANCELLED not between", value1, value2, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andCancelledAtIsNull() {
            addCriterion("CANCELLED_AT is null");
            return (Criteria) this;
        }

        public Criteria andCancelledAtIsNotNull() {
            addCriterion("CANCELLED_AT is not null");
            return (Criteria) this;
        }

        public Criteria andCancelledAtEqualTo(Date value) {
            addCriterion("CANCELLED_AT =", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtNotEqualTo(Date value) {
            addCriterion("CANCELLED_AT <>", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtGreaterThan(Date value) {
            addCriterion("CANCELLED_AT >", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtGreaterThanOrEqualTo(Date value) {
            addCriterion("CANCELLED_AT >=", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtLessThan(Date value) {
            addCriterion("CANCELLED_AT <", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtLessThanOrEqualTo(Date value) {
            addCriterion("CANCELLED_AT <=", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtIn(List<Date> values) {
            addCriterion("CANCELLED_AT in", values, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtNotIn(List<Date> values) {
            addCriterion("CANCELLED_AT not in", values, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtBetween(Date value1, Date value2) {
            addCriterion("CANCELLED_AT between", value1, value2, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtNotBetween(Date value1, Date value2) {
            addCriterion("CANCELLED_AT not between", value1, value2, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeIsNull() {
            addCriterion("VOUCHER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeIsNotNull() {
            addCriterion("VOUCHER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeEqualTo(String value) {
            addCriterion("VOUCHER_CODE =", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotEqualTo(String value) {
            addCriterion("VOUCHER_CODE <>", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeGreaterThan(String value) {
            addCriterion("VOUCHER_CODE >", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeGreaterThanOrEqualTo(String value) {
            addCriterion("VOUCHER_CODE >=", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeLessThan(String value) {
            addCriterion("VOUCHER_CODE <", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeLessThanOrEqualTo(String value) {
            addCriterion("VOUCHER_CODE <=", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeLike(String value) {
            addCriterion("VOUCHER_CODE like", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotLike(String value) {
            addCriterion("VOUCHER_CODE not like", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeIn(List<String> values) {
            addCriterion("VOUCHER_CODE in", values, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotIn(List<String> values) {
            addCriterion("VOUCHER_CODE not in", values, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeBetween(String value1, String value2) {
            addCriterion("VOUCHER_CODE between", value1, value2, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotBetween(String value1, String value2) {
            addCriterion("VOUCHER_CODE not between", value1, value2, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherDateIsNull() {
            addCriterion("VOUCHER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andVoucherDateIsNotNull() {
            addCriterion("VOUCHER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andVoucherDateEqualTo(String value) {
            addCriterion("VOUCHER_DATE =", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotEqualTo(String value) {
            addCriterion("VOUCHER_DATE <>", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateGreaterThan(String value) {
            addCriterion("VOUCHER_DATE >", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateGreaterThanOrEqualTo(String value) {
            addCriterion("VOUCHER_DATE >=", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateLessThan(String value) {
            addCriterion("VOUCHER_DATE <", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateLessThanOrEqualTo(String value) {
            addCriterion("VOUCHER_DATE <=", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateLike(String value) {
            addCriterion("VOUCHER_DATE like", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotLike(String value) {
            addCriterion("VOUCHER_DATE not like", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateIn(List<String> values) {
            addCriterion("VOUCHER_DATE in", values, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotIn(List<String> values) {
            addCriterion("VOUCHER_DATE not in", values, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateBetween(String value1, String value2) {
            addCriterion("VOUCHER_DATE between", value1, value2, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotBetween(String value1, String value2) {
            addCriterion("VOUCHER_DATE not between", value1, value2, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherOpIsNull() {
            addCriterion("VOUCHER_OP is null");
            return (Criteria) this;
        }

        public Criteria andVoucherOpIsNotNull() {
            addCriterion("VOUCHER_OP is not null");
            return (Criteria) this;
        }

        public Criteria andVoucherOpEqualTo(String value) {
            addCriterion("VOUCHER_OP =", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotEqualTo(String value) {
            addCriterion("VOUCHER_OP <>", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpGreaterThan(String value) {
            addCriterion("VOUCHER_OP >", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpGreaterThanOrEqualTo(String value) {
            addCriterion("VOUCHER_OP >=", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpLessThan(String value) {
            addCriterion("VOUCHER_OP <", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpLessThanOrEqualTo(String value) {
            addCriterion("VOUCHER_OP <=", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpLike(String value) {
            addCriterion("VOUCHER_OP like", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotLike(String value) {
            addCriterion("VOUCHER_OP not like", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpIn(List<String> values) {
            addCriterion("VOUCHER_OP in", values, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotIn(List<String> values) {
            addCriterion("VOUCHER_OP not in", values, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpBetween(String value1, String value2) {
            addCriterion("VOUCHER_OP between", value1, value2, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotBetween(String value1, String value2) {
            addCriterion("VOUCHER_OP not between", value1, value2, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNull() {
            addCriterion("CANCEL_REASON is null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNotNull() {
            addCriterion("CANCEL_REASON is not null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonEqualTo(String value) {
            addCriterion("CANCEL_REASON =", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotEqualTo(String value) {
            addCriterion("CANCEL_REASON <>", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThan(String value) {
            addCriterion("CANCEL_REASON >", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThanOrEqualTo(String value) {
            addCriterion("CANCEL_REASON >=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThan(String value) {
            addCriterion("CANCEL_REASON <", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThanOrEqualTo(String value) {
            addCriterion("CANCEL_REASON <=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLike(String value) {
            addCriterion("CANCEL_REASON like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotLike(String value) {
            addCriterion("CANCEL_REASON not like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIn(List<String> values) {
            addCriterion("CANCEL_REASON in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotIn(List<String> values) {
            addCriterion("CANCEL_REASON not in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonBetween(String value1, String value2) {
            addCriterion("CANCEL_REASON between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotBetween(String value1, String value2) {
            addCriterion("CANCEL_REASON not between", value1, value2, "cancelReason");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}